Pandas Profiling Report

Dataset statistics

Number of variables	14
Number of observations	106594
Missing cells	106594
Missing cells (%)	7.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	18.0 MiB
Average record size in memory	177.0 B

Variable types

DateTime	1
Numeric	11
Categorical	1
Unsupported	1

Alerts

`ghi_pyr` is highly overall correlated with `ghi_rsi` and 3 other fields	High correlation
`ghi_rsi` is highly overall correlated with `ghi_pyr` and 2 other fields	High correlation
`dni` is highly overall correlated with `ghi_pyr` and 2 other fields	High correlation
`dhi` is highly overall correlated with `ghi_pyr` and 2 other fields	High correlation
`air_temperature` is highly overall correlated with `ghi_pyr` and 2 other fields	High correlation
`wind_speed` is highly overall correlated with `wind_speed_of_gust` and 1 other fields	High correlation
`wind_speed_of_gust` is highly overall correlated with `air_temperature` and 2 other fields	High correlation
`barometric_pressure` is highly overall correlated with `air_temperature` and 2 other fields	High correlation
`sensor_cleaning` is highly imbalanced (99.0%)	Imbalance
`comments` has 106594 (100.0%) missing values	Missing
`time` has unique values	Unique
`comments` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`ghi_pyr` has 51912 (48.7%) zeros	Zeros
`ghi_rsi` has 46524 (43.6%) zeros	Zeros
`dni` has 58707 (55.1%) zeros	Zeros
`dhi` has 46524 (43.6%) zeros	Zeros

Reproduction

Analysis started	2023-07-13 14:25:40.058522
Analysis finished	2023-07-13 14:26:15.390191
Duration	35.33 seconds
Software version	ydata-profiling vv4.3.1
Download configuration	config.json

time
Date

UNIQUE

Distinct	106594
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	832.9 KiB

Minimum	2015-04-21 18:30:00
Maximum	2017-05-01 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

ghi_pyr
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	10332
Distinct (%)	9.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	249.03033

Minimum	0
Maximum	1151.2
Zeros	51912
Zeros (%)	48.7%
Negative	0
Negative (%)	0.0%
Memory size	832.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	4
Q3	523.7
95-th percentile	908.7
Maximum	1151.2
Range	1151.2
Interquartile range (IQR)	523.7

Descriptive statistics

Standard deviation	329.9626
Coefficient of variation (CV)	1.3249896
Kurtosis	-0.65099626
Mean	249.03033
Median Absolute Deviation (MAD)	4
Skewness	0.9451745
Sum	26545139
Variance	108875.32
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	51912	48.7%
0.2	71	0.1%
0.3	63	0.1%
0.1	60	0.1%
1.1	60	0.1%
0.5	60	0.1%
0.4	55	0.1%
0.6	50	< 0.1%
1.2	48	< 0.1%
1.5	47	< 0.1%
Other values (10322)	54168	50.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	51912	48.7%
0.1	60	0.1%
0.2	71	0.1%
0.3	63	0.1%
0.4	55	0.1%
0.5	60	0.1%
0.6	50	< 0.1%
0.7	41	< 0.1%
0.8	43	< 0.1%
0.9	37	< 0.1%

Value	Count	Frequency (%)
1151.2	1	< 0.1%
1126	1	< 0.1%
1122.4	1	< 0.1%
1116.2	1	< 0.1%
1113.7	1	< 0.1%
1108	1	< 0.1%
1106.8	1	< 0.1%
1096	1	< 0.1%
1092.9	1	< 0.1%
1091.2	1	< 0.1%

ghi_rsi
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	9918
Distinct (%)	9.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	239.59901

Minimum	0
Maximum	1100.9
Zeros	46524
Zeros (%)	43.6%
Negative	0
Negative (%)	0.0%
Memory size	832.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	3.5
Q3	505.1
95-th percentile	868.5
Maximum	1100.9
Range	1100.9
Interquartile range (IQR)	505.1

Descriptive statistics

Standard deviation	316.63119
Coefficient of variation (CV)	1.3215046
Kurtosis	-0.68002644
Mean	239.59901
Median Absolute Deviation (MAD)	3.5
Skewness	0.93467279
Sum	25539817
Variance	100255.31
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	46524	43.6%
0.1	1994	1.9%
0.2	1687	1.6%
0.3	623	0.6%
0.4	188	0.2%
0.5	186	0.2%
0.7	143	0.1%
0.6	136	0.1%
1.2	132	0.1%
1.1	116	0.1%
Other values (9908)	54865	51.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	46524	43.6%
0.1	1994	1.9%
0.2	1687	1.6%
0.3	623	0.6%
0.4	188	0.2%
0.5	186	0.2%
0.6	136	0.1%
0.7	143	0.1%
0.8	115	0.1%
0.9	110	0.1%

Value	Count	Frequency (%)
1100.9	1	< 0.1%
1082.4	1	< 0.1%
1077.3	1	< 0.1%
1075.9	1	< 0.1%
1070.5	1	< 0.1%
1063.9	1	< 0.1%
1061.9	1	< 0.1%
1055.4	1	< 0.1%
1054.3	1	< 0.1%
1046.4	1	< 0.1%

dni
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	8960
Distinct (%)	8.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	202.61395

Minimum	0
Maximum	993.9
Zeros	58707
Zeros (%)	55.1%
Negative	0
Negative (%)	0.0%
Memory size	832.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	443.2
95-th percentile	736
Maximum	993.9
Range	993.9
Interquartile range (IQR)	443.2

Descriptive statistics

Standard deviation	275.36803
Coefficient of variation (CV)	1.3590774
Kurtosis	-0.65813467
Mean	202.61395
Median Absolute Deviation (MAD)	0
Skewness	0.94488169
Sum	21597431
Variance	75827.551
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	58707	55.1%
3.1	23	< 0.1%
0.4	21	< 0.1%
3.4	19	< 0.1%
0.3	19	< 0.1%
0.2	18	< 0.1%
0.1	18	< 0.1%
2.5	17	< 0.1%
3.8	17	< 0.1%
670	17	< 0.1%
Other values (8950)	47718	44.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	58707	55.1%
0.1	18	< 0.1%
0.2	18	< 0.1%
0.3	19	< 0.1%
0.4	21	< 0.1%
0.5	9	< 0.1%
0.6	14	< 0.1%
0.7	15	< 0.1%
0.8	12	< 0.1%
0.9	9	< 0.1%

Value	Count	Frequency (%)
993.9	1	< 0.1%
989.2	1	< 0.1%
986.5	1	< 0.1%
982.1	1	< 0.1%
981.2	1	< 0.1%
980.9	1	< 0.1%
980.5	1	< 0.1%
978.7	1	< 0.1%
977.8	1	< 0.1%
976.5	1	< 0.1%

dhi
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	5521
Distinct (%)	5.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	100.45506

Minimum	0
Maximum	673
Zeros	46524
Zeros (%)	43.6%
Negative	0
Negative (%)	0.0%
Memory size	832.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	3.5
Q3	188.1
95-th percentile	360.5
Maximum	673
Range	673
Interquartile range (IQR)	188.1

Descriptive statistics

Standard deviation	130.82675
Coefficient of variation (CV)	1.3023411
Kurtosis	0.57838244
Mean	100.45506
Median Absolute Deviation (MAD)	3.5
Skewness	1.1743655
Sum	10707906
Variance	17115.638
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	46524	43.6%
0.1	1994	1.9%
0.2	1687	1.6%
0.3	623	0.6%
0.4	188	0.2%
0.5	186	0.2%
0.7	143	0.1%
0.6	136	0.1%
1.2	132	0.1%
1.1	116	0.1%
Other values (5511)	54865	51.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	46524	43.6%
0.1	1994	1.9%
0.2	1687	1.6%
0.3	623	0.6%
0.4	188	0.2%
0.5	186	0.2%
0.6	136	0.1%
0.7	143	0.1%
0.8	115	0.1%
0.9	110	0.1%

Value	Count	Frequency (%)
673	1	< 0.1%
672.5	1	< 0.1%
670	1	< 0.1%
665.2	1	< 0.1%
664.5	1	< 0.1%
657.1	1	< 0.1%
649.6	1	< 0.1%
649.3	1	< 0.1%
649.1	1	< 0.1%
647.4	1	< 0.1%

air_temperature
Real number (ℝ)

HIGH CORRELATION

Distinct	410
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	27.692962

Minimum	7.8
Maximum	49.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	832.9 KiB

Quantile statistics

Minimum	7.8
5-th percentile	15.6
Q1	23
median	28.1
Q3	32.4
95-th percentile	38.8
Maximum	49.5
Range	41.7
Interquartile range (IQR)	9.4

Descriptive statistics

Standard deviation	6.9149428
Coefficient of variation (CV)	0.24970037
Kurtosis	-0.38605333
Mean	27.692962
Median Absolute Deviation (MAD)	4.6
Skewness	-0.12704659
Sum	2951903.6
Variance	47.816434
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28.4	917	0.9%
28.9	906	0.8%
29.1	902	0.8%
28.6	875	0.8%
28.1	868	0.8%
27.9	865	0.8%
29.2	829	0.8%
29.4	827	0.8%
27.1	814	0.8%
26.9	810	0.8%
Other values (400)	97981	91.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7.8	2	< 0.1%
7.9	1	< 0.1%
8	2	< 0.1%
8.1	1	< 0.1%
8.2	3	< 0.1%
8.3	1	< 0.1%
8.4	1	< 0.1%
8.5	1	< 0.1%
8.6	1	< 0.1%
8.7	2	< 0.1%

Value	Count	Frequency (%)
49.5	1	< 0.1%
49	2	< 0.1%
48.9	3	< 0.1%
48.8	2	< 0.1%
48.7	3	< 0.1%
48.6	1	< 0.1%
48.5	2	< 0.1%
48.4	2	< 0.1%
48.3	1	< 0.1%
48.2	1	< 0.1%

relative_humidity
Real number (ℝ)

Distinct	970
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	51.710956

Minimum	2.7
Maximum	99.9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	832.9 KiB

Quantile statistics

Minimum	2.7
5-th percentile	18.8
Q1	36
median	50.8
Q3	69.2
95-th percentile	83.2
Maximum	99.9
Range	97.2
Interquartile range (IQR)	33.2

Descriptive statistics

Standard deviation	20.344793
Coefficient of variation (CV)	0.39343293
Kurtosis	-0.86679879
Mean	51.710956
Median Absolute Deviation (MAD)	16.4
Skewness	-0.0074660303
Sum	5512077.6
Variance	413.9106
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
36	232	0.2%
75.5	228	0.2%
74.5	222	0.2%
46.1	222	0.2%
46.5	220	0.2%
73.8	220	0.2%
76.8	219	0.2%
42.9	217	0.2%
77	216	0.2%
48	215	0.2%
Other values (960)	104383	97.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.7	2	< 0.1%
2.9	2	< 0.1%
3	1	< 0.1%
3.1	3	< 0.1%
3.2	2	< 0.1%
3.3	2	< 0.1%
3.5	4	< 0.1%
3.6	3	< 0.1%
3.7	5	< 0.1%
3.8	4	< 0.1%

Value	Count	Frequency (%)
99.9	4	< 0.1%
99.8	3	< 0.1%
99.7	2	< 0.1%
99.6	2	< 0.1%
99.5	5	< 0.1%
99.4	15	< 0.1%
99.3	15	< 0.1%
99.2	9	< 0.1%
99.1	9	< 0.1%
99	5	< 0.1%

wind_speed
Real number (ℝ)

HIGH CORRELATION

Distinct	160
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.9719365

Minimum	0
Maximum	18.1
Zeros	680
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	832.9 KiB

Quantile statistics

Minimum	0
5-th percentile	1.4
Q1	2.9
median	4.6
Q3	6.9
95-th percentile	9.5
Maximum	18.1
Range	18.1
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.5674802
Coefficient of variation (CV)	0.51639441
Kurtosis	-0.55304258
Mean	4.9719365
Median Absolute Deviation (MAD)	1.9
Skewness	0.39806157
Sum	529978.6
Variance	6.5919547
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.8	1779	1.7%
3	1771	1.7%
3.5	1728	1.6%
2.6	1722	1.6%
3.1	1717	1.6%
2.9	1690	1.6%
3.2	1689	1.6%
3.8	1679	1.6%
2.5	1670	1.6%
3.6	1648	1.5%
Other values (150)	89501	84.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	680	0.6%
0.1	195	0.2%
0.2	210	0.2%
0.3	212	0.2%
0.4	228	0.2%
0.5	231	0.2%
0.6	300	0.3%
0.7	289	0.3%
0.8	353	0.3%
0.9	386	0.4%

Value	Count	Frequency (%)
18.1	1	< 0.1%
17.7	1	< 0.1%
17.2	1	< 0.1%
16.6	3	< 0.1%
15.8	2	< 0.1%
15.7	1	< 0.1%
15.6	3	< 0.1%
15.5	1	< 0.1%
15.4	1	< 0.1%
15.3	2	< 0.1%

wind_speed_of_gust
Real number (ℝ)

HIGH CORRELATION

Distinct	199
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.5248344

Minimum	0
Maximum	29.5
Zeros	489
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	832.9 KiB

Quantile statistics

Minimum	0
5-th percentile	2.4
Q1	4.4
median	6.9
Q3	10.4
95-th percentile	14.2
Maximum	29.5
Range	29.5
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.7684093
Coefficient of variation (CV)	0.50079631
Kurtosis	-0.62278485
Mean	7.5248344
Median Absolute Deviation (MAD)	2.8
Skewness	0.40649423
Sum	802102.2
Variance	14.200908
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.1	3067	2.9%
4.9	2989	2.8%
5.7	2806	2.6%
3.4	2760	2.6%
5.4	2687	2.5%
4.6	2640	2.5%
5.2	2631	2.5%
3.9	2619	2.5%
4.4	2600	2.4%
6.4	2526	2.4%
Other values (189)	79269	74.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	489	0.5%
0.4	23	< 0.1%
0.6	1	< 0.1%
0.7	1	< 0.1%
0.8	127	0.1%
1	10	< 0.1%
1.1	379	0.4%
1.2	4	< 0.1%
1.3	1	< 0.1%
1.4	442	0.4%

Value	Count	Frequency (%)
29.5	1	< 0.1%
27.4	1	< 0.1%
25.7	2	< 0.1%
25.4	1	< 0.1%
25.2	1	< 0.1%
25	1	< 0.1%
23.2	1	< 0.1%
22.2	1	< 0.1%
21.9	2	< 0.1%
21.7	2	< 0.1%

wind_from_direction_st_dev
Real number (ℝ)

Distinct	648
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.725061

Minimum	0
Maximum	93.1
Zeros	971
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	832.9 KiB

Quantile statistics

Minimum	0
5-th percentile	3.7
Q1	10.7
median	14.9
Q3	17.9
95-th percentile	25.7
Maximum	93.1
Range	93.1
Interquartile range (IQR)	7.2

Descriptive statistics

Standard deviation	6.8215562
Coefficient of variation (CV)	0.46326167
Kurtosis	6.3682179
Mean	14.725061
Median Absolute Deviation (MAD)	3.6
Skewness	1.1539733
Sum	1569603.1
Variance	46.533628
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16.9	1115	1.0%
17.1	1101	1.0%
16.6	1050	1.0%
17.6	1039	1.0%
16.4	1031	1.0%
16.1	1031	1.0%
17.4	1013	1.0%
16.8	1007	0.9%
0	971	0.9%
17.2	957	0.9%
Other values (638)	96279	90.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	971	0.9%
0.1	609	0.6%
0.2	243	0.2%
0.3	86	0.1%
0.4	79	0.1%
0.5	84	0.1%
0.6	68	0.1%
0.7	80	0.1%
0.8	83	0.1%
0.9	72	0.1%

Value	Count	Frequency (%)
93.1	1	< 0.1%
84.6	1	< 0.1%
82.5	1	< 0.1%
81	1	< 0.1%
79.8	1	< 0.1%
79.7	1	< 0.1%
78.6	1	< 0.1%
78.1	1	< 0.1%
77.8	1	< 0.1%
77.7	1	< 0.1%

wind_from_direction
Real number (ℝ)

Distinct	3598
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	188.45567

Minimum	0
Maximum	360
Zeros	519
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	832.9 KiB

Quantile statistics

Minimum	0
5-th percentile	8.865
Q1	162.6
median	209.3
Q3	230.4
95-th percentile	349.1
Maximum	360
Range	360
Interquartile range (IQR)	67.8

Descriptive statistics

Standard deviation	95.029482
Coefficient of variation (CV)	0.50425377
Kurtosis	-0.30019307
Mean	188.45567
Median Absolute Deviation (MAD)	26.8
Skewness	-0.49972187
Sum	20088244
Variance	9030.6025
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	519	0.5%
211.7	175	0.2%
209.1	171	0.2%
214.2	171	0.2%
210.7	170	0.2%
210.3	169	0.2%
209.2	168	0.2%
209	164	0.2%
209.5	164	0.2%
218	163	0.2%
Other values (3588)	104560	98.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	519	0.5%
0.1	38	< 0.1%
0.2	53	< 0.1%
0.3	37	< 0.1%
0.4	41	< 0.1%
0.5	62	0.1%
0.6	52	< 0.1%
0.7	59	0.1%
0.8	44	< 0.1%
0.9	46	< 0.1%

Value	Count	Frequency (%)
360	24	< 0.1%
359.9	69	0.1%
359.8	52	< 0.1%
359.7	49	< 0.1%
359.6	64	0.1%
359.5	43	< 0.1%
359.4	55	0.1%
359.3	53	< 0.1%
359.2	52	< 0.1%
359.1	46	< 0.1%

barometric_pressure
Real number (ℝ)

HIGH CORRELATION

Distinct	363
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1000.8149

Minimum	982.5
Maximum	1019
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	832.9 KiB

Quantile statistics

Minimum	982.5
5-th percentile	989.7
Q1	994.9
median	1000.5
Q3	1007.2
95-th percentile	1011.5
Maximum	1019
Range	36.5
Interquartile range (IQR)	12.3

Descriptive statistics

Standard deviation	7.1769299
Coefficient of variation (CV)	0.0071710862
Kurtosis	-1.0711052
Mean	1000.8149
Median Absolute Deviation (MAD)	6.1
Skewness	-0.029299672
Sum	1.0668086 × 10⁸
Variance	51.508323
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
997.4	723	0.7%
995.5	656	0.6%
996.6	630	0.6%
1007.7	618	0.6%
996.3	617	0.6%
1006.4	617	0.6%
1008.4	611	0.6%
1009.5	601	0.6%
1007.2	597	0.6%
1007.8	596	0.6%
Other values (353)	100328	94.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
982.5	2	< 0.1%
982.6	5	< 0.1%
982.7	1	< 0.1%
982.8	3	< 0.1%
982.9	3	< 0.1%
983	5	< 0.1%
983.2	4	< 0.1%
983.4	2	< 0.1%
983.5	1	< 0.1%
983.6	3	< 0.1%

Value	Count	Frequency (%)
1019	5	< 0.1%
1018.9	4	< 0.1%
1018.8	3	< 0.1%
1018.7	1	< 0.1%
1018.5	3	< 0.1%
1018.4	2	< 0.1%
1018.3	6	< 0.1%
1018.2	9	< 0.1%
1018.1	7	< 0.1%
1018	6	< 0.1%

sensor_cleaning
Categorical

IMBALANCE

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.1 MiB

0.0	106440
1.0	153
0.1	1

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	319782
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
0.0	106440	99.9%
1.0	153	0.1%
0.1	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	106440	99.9%
1.0	153	0.1%
0.1	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	213034	66.6%
.	106594	33.3%
1	154	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	213188	66.7%
Other Punctuation	106594	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	213034	99.9%
1	154	0.1%

Other Punctuation

Value	Count	Frequency (%)
.	106594	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	319782	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	213034	66.6%
.	106594	33.3%
1	154	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	319782	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	213034	66.6%
.	106594	33.3%
1	154	< 0.1%

comments
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	106594
Missing (%)	100.0%
Memory size	832.9 KiB

Auto

Heatmap
Table

	ghi_pyr	ghi_rsi	dni	dhi	air_temperature	relative_humidity	wind_speed	wind_speed_of_gust	wind_from_direction_st_dev	wind_from_direction	barometric_pressure	sensor_cleaning
ghi_pyr	1.000	0.981	0.933	0.948	0.506	-0.429	0.116	0.187	0.461	-0.177	-0.086	0.040
ghi_rsi	0.981	1.000	0.917	0.967	0.478	-0.440	0.091	0.161	0.450	-0.189	-0.058	0.041
dni	0.933	0.917	1.000	0.840	0.404	-0.468	0.031	0.098	0.435	-0.204	0.051	0.042
dhi	0.948	0.967	0.840	1.000	0.485	-0.384	0.141	0.204	0.432	-0.175	-0.121	0.033
air_temperature	0.506	0.478	0.404	0.485	1.000	-0.294	0.470	0.527	0.300	-0.018	-0.704	0.015
relative_humidity	-0.429	-0.440	-0.468	-0.384	-0.294	1.000	0.206	0.170	-0.205	0.083	-0.271	0.014
wind_speed	0.116	0.091	0.031	0.141	0.470	0.206	1.000	0.982	0.230	0.147	-0.627	0.000
wind_speed_of_gust	0.187	0.161	0.098	0.204	0.527	0.170	0.982	1.000	0.337	0.140	-0.650	0.000
wind_from_direction_st_dev	0.461	0.450	0.435	0.432	0.300	-0.205	0.230	0.337	1.000	0.007	-0.094	0.015
wind_from_direction	-0.177	-0.189	-0.204	-0.175	-0.018	0.083	0.147	0.140	0.007	1.000	-0.125	0.010
barometric_pressure	-0.086	-0.058	0.051	-0.121	-0.704	-0.271	-0.627	-0.650	-0.094	-0.125	1.000	0.005
sensor_cleaning	0.040	0.041	0.042	0.033	0.015	0.014	0.000	0.000	0.015	0.010	0.005	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	time	ghi_pyr	ghi_rsi	dni	dhi	air_temperature	relative_humidity	wind_speed	wind_speed_of_gust	wind_from_direction_st_dev	wind_from_direction	barometric_pressure	sensor_cleaning	comments
0	2015-04-21 18:30	72.1	43.2	15.0	41.7	38.7	8.6	10.5	13.6	10.4	248.5	998.2	0.0	NaN
1	2015-04-21 18:40	37.3	22.7	0.0	22.7	38.4	8.2	10.5	13.8	10.1	252.7	998.2	0.0	NaN
2	2015-04-21 18:50	4.0	4.3	0.0	4.3	38.0	8.3	8.9	12.2	12.4	242.8	998.5	0.0	NaN
3	2015-04-21 19:00	0.0	1.2	0.0	1.2	37.7	8.8	8.8	12.7	12.6	245.7	998.6	1.0	NaN
4	2015-04-21 19:10	0.0	0.0	0.0	0.0	37.4	9.3	8.4	11.4	12.8	244.1	998.6	1.0	NaN
5	2015-04-21 19:20	0.0	0.0	0.0	0.0	37.1	9.9	7.5	11.2	14.3	239.8	998.7	0.0	NaN
6	2015-04-21 19:30	0.0	0.0	0.0	0.0	36.7	11.1	7.6	11.4	15.4	234.9	998.9	0.0	NaN
7	2015-04-21 19:40	0.0	0.0	0.0	0.0	36.1	13.3	8.1	12.2	16.7	230.8	998.9	0.0	NaN
8	2015-04-21 19:50	0.0	0.0	0.0	0.0	35.8	13.0	8.1	11.9	16.2	231.6	999.1	0.0	NaN
9	2015-04-21 20:00	0.0	0.0	0.0	0.0	35.5	12.6	7.6	10.9	15.9	233.7	999.2	0.0	NaN

	time	air_temperature	relative_humidity	wind_speed	wind_speed_of_gust	wind_from_direction_st_dev	wind_from_direction	barometric_pressure	comments
106584	2017-04-30 22:30	30.2	50.6	3.6	4.9	9.3	209.3	999.8	NaN
106585	2017-04-30 22:40	29.9	51.1	3.5	4.9	9.0	211.0	999.9	NaN
106586	2017-04-30 22:50	29.9	51.2	4.2	5.7	11.3	208.6	999.9	NaN
106587	2017-04-30 23:00	29.6	51.4	4.3	5.4	9.4	211.8	999.9	NaN
106588	2017-04-30 23:10	29.4	51.5	4.2	5.7	10.9	210.7	999.9	NaN
106589	2017-04-30 23:20	29.2	51.9	3.7	5.4	12.1	215.7	999.9	NaN
106590	2017-04-30 23:30	29.1	51.6	4.3	7.2	16.6	222.9	999.9	NaN
106591	2017-04-30 23:40	29.2	48.8	4.0	6.7	16.8	228.7	999.9	NaN
106592	2017-04-30 23:50	29.4	45.8	3.9	6.2	15.7	238.7	999.8	NaN
106593	2017-05-01 00:00	29.4	43.2	4.2	5.9	11.3	248.5	999.8	NaN

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample